package com.cci.kangdao.dao;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.annotation.MapperScan;

/**
 * @author William Du
 * @date 2019/10/30
 */
@MapperScan
public interface SystemTDao {

    /**
     * 通过系统名称获取系统链接地址
     * @param systemName 系统名称
     * @return 系统链接地址
     */
    @Select("select SystemUrl from System_T where Flag = 0 and SystemName = #{systemName}")
    String getSystemUrlBySystemName(@Param("systemName") String systemName);

    @Select("select SystemUrl from System_T where Flag = 0 and SystemName = 'TEST'")
    String getTestSystemUrl();
}
